Performing Table Gap Analysis

You can perform a table gap analysis and find:

  • Tables not being used in mappings
  • Tables existing on mapping without valid source or target

You can perform table gap analysis at the following levels:

  • System
  • Environment
  • Table

To perform table gap analysis, follow these steps:

  1. Go to Application Menu > Data Catalog > Mapping Manager.
  2. In the Workspace Mappings pane, click a project.

    3. The Metadata Tree View pane appears on the right.

    Previewing Data Database

  3. In the Metadata Tree View pane, you can right-click a:
    • System: Use this option to run the analysis on all the tables under a system.
    • Environment: Use this option to run the analysis on all the tables under an environment.
    • Table: Use this option to run the analysis on a table.

    For example, the following image displays the available options when you right-click a system.

    Table Gap Analysis Sys

  4. Click Table Gap Analysis.

    5. The Table Gap Analysis page appears.

    Table Gap Analysis Page

  5. Select projects and mappings.
  6. Click Icon Ok Database Options.

    7. The Table Gap Analysis Report for the selected projects and mappings appears.

    Table Gap Analysis Report